SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_UpdateRequireClickNumber]
    (
      @JOL_Require_ID INT
    )
AS 
    UPDATE  dbo.JOL_Require
    SET     JOL_Require_ClickNumber = JOL_Require_ClickNumber + 1
    WHERE   JOL_Require_ID=@JOL_Require_ID

GO
